Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ConsumerRegistrationStateID (PK) | Token ID for an instance of a ConsumerRegistrationState. | ID_CNS_RGSTN_ST | Identity | integer | |
ConsumerID (FK) | Token ID for a Consumer instance. | ID_CNS | Identity | integer | Consumer(PA_CNS) |
RegistrationStateCode (FK) | Code value that designates a type of enrollment condition. The list is determined by the retailer. Common examples include: REGISTERED_VALIDATED - consumer is registered but information is not validated REGISTERED_UNVALIDATE - consumer is registered and information has been validated UNREGISTERED - consumer has NOT registered. Others as required by the retailer. | CD_CNS_RGSTN_ST | Code | varchar(20) | RegistrationState(CO_ST_RGSTN) |
CurrentStatusCode | Indicated the current status of this memorialized consumer registration state. Valid values are: ACTIVE INACTIVE | CD_CRT_RGSTN_ST | Code | varchar(20) | |
EffectiveDate | Date this registration state applies to this consumer | DT_EF | EffectiveDate | date | |
ExpirationDate | Date this registration state no longer applies to this consumer. | DT_EP | ExpirationDate | date | |
ConsumerRegistrationDoNotCallFlag | Boolean attribute that indicates if a retailer is allowed to call a consumer or not. If "FALSE' it means DO NOT CALL | FL_CNS_DO_NOT_CALL | Flag | integer | |
ConsumerRegistrationDoNotShareFlag | Boolean indicator that if FALSE means a retaile may NOT SHARE consumer information with other retailers, vendors or other external parties. | FL_CNS_DO_NOT_SHR | Flag | integer | |
ConsumerRegistrationDoNotEmailFlag | Boolean indicator that if FALSE means a retailer may not send unsolicited emails to the consumer. | FL_CNS_DO_NOT_EMAIL | Flag | integer | |
ConsumerRegistrationDoNotTrackFlag | A boolean indicator that if FALSE means a retailer may not track and analyze a consumer's purchasing patterns for analytic and reporting purposes. | FL_CNS_DO_NOT_TRK | Flag | integer | |
RegistrationEventID (FK) | Token ID for a registration event | ID_RGSTN_EV | Identity | integer | RegistrationEvent(EV_RGSTN) |